/****** Object:  Stored Procedure dbo.asi_GetOrderResponseStart    ******/

CREATE  PROCEDURE [dbo].[asi_GetOrderResponseStart]

@userKey uniqueidentifier,
@rangeBegin float output,
@rangeEnd float output
AS
DECLARE @newGuid as uniqueidentifier
declare @EveryoneFullControlAccessKey uniqueidentifier
select @EveryoneFullControlAccessKey = ParameterValue from SystemConfig
    where ParameterName = 'Security.Token.EveryoneFullControlAccessKey'
set @rangeBegin = 0
set @rangeEnd = 0
BEGIN TRAN
-- Get the ending value
SELECT    @rangeEnd =  max(ORDER_NUMBER)
FROM    Orders
-- Check to make sure the counter exists - create it if not
IF NOT EXISTS(SELECT 1 FROM SystemConfig WHERE ParameterName='OrderResponseRangeStart')
BEGIN
    SELECT @newGuid = newid()
    INSERT SystemConfig (SystemConfigKey, ParameterName, ParameterValue, Description)
    VALUES(    @newGuid,
        'OrderResponseRangeStart',
        CAST(@rangeEnd As nvarchar(100)),
        'Ending point in the Orders table already processed by response acquisition.')
END
-- Get the beginning value
SELECT    @rangeBegin = CAST(ParameterValue As float)
FROM    SystemConfig
WHERE    ParameterName = 'OrderResponseRangeStart'
IF @rangeBegin is NULL
    SET @rangeBegin = 0
-- Set the ending value
UPDATE    SystemConfig
SET    ParameterValue = CAST(@rangeEnd As nvarchar(100))
WHERE    ParameterName = 'OrderResponseRangeStart'
COMMIT TRAN

GO